package com.depthsdata.coe.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-12-27 11:41:50
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class BusinessNodeDAOQueryBean extends BaseQueryBean {
    
    public BusinessNodeDAOQueryBean() {
		super();
    }
	
    public BusinessNodeDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public BusinessNodeDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.Id,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addBusinessProcessIdSelectProperty(){
		addBusinessProcessIdSelectProperty("businessProcessId");
	}
	
    public void addBusinessProcessIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.BusinessProcessId,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.BusinessProcessId,"businessProcessId");
	    }
    }
    
       
		
		
	    
    public void addParentBusinessNodeIdSelectProperty(){
		addParentBusinessNodeIdSelectProperty("parentBusinessNodeId");
	}
	
    public void addParentBusinessNodeIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.ParentBusinessNodeId,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.ParentBusinessNodeId,"parentBusinessNodeId");
	    }
    }
    
       
		
		
	    
    public void addPreBusinesNodeIdSelectProperty(){
		addPreBusinesNodeIdSelectProperty("preBusinesNodeId");
	}
	
    public void addPreBusinesNodeIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.PreBusinesNodeId,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.PreBusinesNodeId,"preBusinesNodeId");
	    }
    }
    
       
		
		
	    
    public void addNextBusinessNodeIdSelectProperty(){
		addNextBusinessNodeIdSelectProperty("nextBusinessNodeId");
	}
	
    public void addNextBusinessNodeIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.NextBusinessNodeId,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.NextBusinessNodeId,"nextBusinessNodeId");
	    }
    }
    
       
		
		
	    
    public void addBusinessNodeNameSelectProperty(){
		addBusinessNodeNameSelectProperty("businessNodeName");
	}
	
    public void addBusinessNodeNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.BusinessNodeName,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.BusinessNodeName,"businessNodeName");
	    }
    }
    
       
		
		
	    
    public void addBusinessNodeTypeSelectProperty(){
		addBusinessNodeTypeSelectProperty("businessNodeType");
	}
	
    public void addBusinessNodeTypeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.BusinessNodeType,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.BusinessNodeType,"businessNodeType");
	    }
    }
    
       
		
		
	    
    public void addDeleteFlagSelectProperty(){
		addDeleteFlagSelectProperty("deleteFlag");
	}
	
    public void addDeleteFlagSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.DeleteFlag,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.DeleteFlag,"deleteFlag");
	    }
    }
    
       
		
		
	    
    public void addStatusSelectProperty(){
		addStatusSelectProperty("status");
	}
	
    public void addStatusSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.Status,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.Status,"status");
	    }
    }
    
       
		
		
	    
    public void addRemarksSelectProperty(){
		addRemarksSelectProperty("remarks");
	}
	
    public void addRemarksSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.Remarks,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.Remarks,"remarks");
	    }
    }
    
       
		
		
	    
    public void addProcessDiagramNodeIdSelectProperty(){
		addProcessDiagramNodeIdSelectProperty("processDiagramNodeId");
	}
	
    public void addProcessDiagramNodeIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessNodeDAO.ProcessDiagramNodeId,aAlias);
		}
		else{
			addSelectProperty(IBusinessNodeDAO.ProcessDiagramNodeId,"processDiagramNodeId");
	    }
    }
    
       
		
		
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addBusinessProcessIdSelectProperty();
   
		
		
	    addParentBusinessNodeIdSelectProperty();
   
		
		
	    addPreBusinesNodeIdSelectProperty();
   
		
		
	    addNextBusinessNodeIdSelectProperty();
   
		
		
	    addBusinessNodeNameSelectProperty();
   
		
		
	    addBusinessNodeTypeSelectProperty();
   
		
		
	    addDeleteFlagSelectProperty();
   
		
		
	    addStatusSelectProperty();
   
		
		
	    addRemarksSelectProperty();
   
		
		
	    addProcessDiagramNodeIdSelectProperty();
   
		
	    }
    
    public static class Criteria extends BaseWhereCriterion<BusinessNodeDAOQueryBean> {
	
        protected Criteria(BusinessNodeDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(IBusinessNodeDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.Id + " is not null AND " + IBusinessNodeDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.Id + " is null OR " + IBusinessNodeDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.Id + " is null OR " + IBusinessNodeDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessProcessIdIsNull() {
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " is null");
            return this;
        }
        public Criteria andBusinessProcessIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " is not null");
            return this;
        }
    
        public Criteria andBusinessProcessIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " is not null AND " + IBusinessNodeDAO.BusinessProcessId + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessProcessIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.BusinessProcessId + " is null OR " + IBusinessNodeDAO.BusinessProcessId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andBusinessProcessIdEqualTo(long value) {
        	return andBusinessProcessIdEqualTo(Long.valueOf(value));
        }
               public Criteria andBusinessProcessIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " = ", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andBusinessProcessIdNotEqualTo(long value) {
        	return andBusinessProcessIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
               
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(long value) {
        	return andBusinessProcessIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " is null OR " + IBusinessNodeDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThan(long value) {
        	return andBusinessProcessIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " >", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThanOrEqualTo(long value) {
        	return andBusinessProcessIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " >=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThan(long value) {
        	return andBusinessProcessIdLessThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " <", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThanOrEqualTo(long value) {
        	return andBusinessProcessIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " <=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessProcessId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andBusinessProcessIdIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
                public Criteria andBusinessProcessIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andBusinessProcessIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andBusinessProcessIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessProcessId + " not in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
		
		public Criteria andBusinessProcessIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessProcessIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessProcessId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
        
                
        public Criteria andBusinessProcessIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andParentBusinessNodeIdIsNull() {
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " is null");
            return this;
        }
        public Criteria andParentBusinessNodeIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " is not null");
            return this;
        }
    
        public Criteria andParentBusinessNodeIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " is not null AND " + IBusinessNodeDAO.ParentBusinessNodeId + " <> ''");
            return this;
        }
    		
    	public Criteria andParentBusinessNodeIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.ParentBusinessNodeId + " is null OR " + IBusinessNodeDAO.ParentBusinessNodeId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andParentBusinessNodeIdEqualTo(long value) {
        	return andParentBusinessNodeIdEqualTo(Long.valueOf(value));
        }
               public Criteria andParentBusinessNodeIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " = ", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andParentBusinessNodeIdNotEqualTo(long value) {
        	return andParentBusinessNodeIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andParentBusinessNodeIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " <>", value, "parentBusinessNodeId");
            return this;
        }
               
        public Criteria andParentBusinessNodeIdNotEqualToOrIsNull(long value) {
        	return andParentBusinessNodeIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andParentBusinessNodeIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " is null OR " + IBusinessNodeDAO.ParentBusinessNodeId + " <>", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andParentBusinessNodeIdGreaterThan(long value) {
        	return andParentBusinessNodeIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andParentBusinessNodeIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " >", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andParentBusinessNodeIdGreaterThanOrEqualTo(long value) {
        	return andParentBusinessNodeIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andParentBusinessNodeIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " >=", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andParentBusinessNodeIdLessThan(long value) {
        	return andParentBusinessNodeIdLessThan(Long.valueOf(value));
        }
                public Criteria andParentBusinessNodeIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " <", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andParentBusinessNodeIdLessThanOrEqualTo(long value) {
        	return andParentBusinessNodeIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andParentBusinessNodeIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " <=", value, "parentBusinessNodeId");
            return this;
        }
        
        public Criteria andParentBusinessNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ParentBusinessNodeId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParentBusinessNodeIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andParentBusinessNodeIdIn(long[] values) {
        	if(values.length == 1){
        		return andParentBusinessNodeIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " in", values, "parentBusinessNodeId");
            	return this;
            }
        }
        
        public Criteria andParentBusinessNodeIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andParentBusinessNodeIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not in", values, "parentBusinessNodeId");
            	return this;
            }
        }
        
                public Criteria andParentBusinessNodeIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andParentBusinessNodeIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " in", values, "parentBusinessNodeId");
            	return this;
            }
        }
        public Criteria andParentBusinessNodeIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andParentBusinessNodeIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not in", values, "parentBusinessNodeId");
            	return this;
            }
        }
        
        public Criteria andParentBusinessNodeIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andParentBusinessNodeIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " in", Arrays.asList(values), "parentBusinessNodeId");
            	return this;
            }
        }
        public Criteria andParentBusinessNodeIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andParentBusinessNodeIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not in", Arrays.asList(values), "parentBusinessNodeId");
            	return this;
            }
        }
		
		public Criteria andParentBusinessNodeIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andParentBusinessNodeIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andParentBusinessNodeIdBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " between", value1, value2, "parentBusinessNodeId");
            return this;
        }
                public Criteria andParentBusinessNodeIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " between", value1, value2, "parentBusinessNodeId");
            return this;
        }
        
                
        public Criteria andParentBusinessNodeIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not between", value1, value2, "parentBusinessNodeId");
            return this;
        }
                public Criteria andParentBusinessNodeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.ParentBusinessNodeId + " not between", value1, value2, "parentBusinessNodeId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andPreBusinesNodeIdIsNull() {
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " is null");
            return this;
        }
        public Criteria andPreBusinesNodeIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " is not null");
            return this;
        }
    
        public Criteria andPreBusinesNodeIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " is not null AND " + IBusinessNodeDAO.PreBusinesNodeId + " <> ''");
            return this;
        }
    		
    	public Criteria andPreBusinesNodeIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.PreBusinesNodeId + " is null OR " + IBusinessNodeDAO.PreBusinesNodeId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andPreBusinesNodeIdEqualTo(long value) {
        	return andPreBusinesNodeIdEqualTo(Long.valueOf(value));
        }
               public Criteria andPreBusinesNodeIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " = ", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andPreBusinesNodeIdNotEqualTo(long value) {
        	return andPreBusinesNodeIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andPreBusinesNodeIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " <>", value, "preBusinesNodeId");
            return this;
        }
               
        public Criteria andPreBusinesNodeIdNotEqualToOrIsNull(long value) {
        	return andPreBusinesNodeIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andPreBusinesNodeIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " is null OR " + IBusinessNodeDAO.PreBusinesNodeId + " <>", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andPreBusinesNodeIdGreaterThan(long value) {
        	return andPreBusinesNodeIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andPreBusinesNodeIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " >", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andPreBusinesNodeIdGreaterThanOrEqualTo(long value) {
        	return andPreBusinesNodeIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andPreBusinesNodeIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " >=", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPreBusinesNodeIdLessThan(long value) {
        	return andPreBusinesNodeIdLessThan(Long.valueOf(value));
        }
                public Criteria andPreBusinesNodeIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " <", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPreBusinesNodeIdLessThanOrEqualTo(long value) {
        	return andPreBusinesNodeIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andPreBusinesNodeIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " <=", value, "preBusinesNodeId");
            return this;
        }
        
        public Criteria andPreBusinesNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.PreBusinesNodeId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPreBusinesNodeIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andPreBusinesNodeIdIn(long[] values) {
        	if(values.length == 1){
        		return andPreBusinesNodeIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " in", values, "preBusinesNodeId");
            	return this;
            }
        }
        
        public Criteria andPreBusinesNodeIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andPreBusinesNodeIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not in", values, "preBusinesNodeId");
            	return this;
            }
        }
        
                public Criteria andPreBusinesNodeIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andPreBusinesNodeIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " in", values, "preBusinesNodeId");
            	return this;
            }
        }
        public Criteria andPreBusinesNodeIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andPreBusinesNodeIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not in", values, "preBusinesNodeId");
            	return this;
            }
        }
        
        public Criteria andPreBusinesNodeIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andPreBusinesNodeIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " in", Arrays.asList(values), "preBusinesNodeId");
            	return this;
            }
        }
        public Criteria andPreBusinesNodeIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andPreBusinesNodeIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not in", Arrays.asList(values), "preBusinesNodeId");
            	return this;
            }
        }
		
		public Criteria andPreBusinesNodeIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andPreBusinesNodeIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPreBusinesNodeIdBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " between", value1, value2, "preBusinesNodeId");
            return this;
        }
                public Criteria andPreBusinesNodeIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " between", value1, value2, "preBusinesNodeId");
            return this;
        }
        
                
        public Criteria andPreBusinesNodeIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not between", value1, value2, "preBusinesNodeId");
            return this;
        }
                public Criteria andPreBusinesNodeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.PreBusinesNodeId + " not between", value1, value2, "preBusinesNodeId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andNextBusinessNodeIdIsNull() {
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " is null");
            return this;
        }
        public Criteria andNextBusinessNodeIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " is not null");
            return this;
        }
    
        public Criteria andNextBusinessNodeIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " is not null AND " + IBusinessNodeDAO.NextBusinessNodeId + " <> ''");
            return this;
        }
    		
    	public Criteria andNextBusinessNodeIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.NextBusinessNodeId + " is null OR " + IBusinessNodeDAO.NextBusinessNodeId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andNextBusinessNodeIdEqualTo(long value) {
        	return andNextBusinessNodeIdEqualTo(Long.valueOf(value));
        }
               public Criteria andNextBusinessNodeIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " = ", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andNextBusinessNodeIdNotEqualTo(long value) {
        	return andNextBusinessNodeIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andNextBusinessNodeIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " <>", value, "nextBusinessNodeId");
            return this;
        }
               
        public Criteria andNextBusinessNodeIdNotEqualToOrIsNull(long value) {
        	return andNextBusinessNodeIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andNextBusinessNodeIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " is null OR " + IBusinessNodeDAO.NextBusinessNodeId + " <>", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andNextBusinessNodeIdGreaterThan(long value) {
        	return andNextBusinessNodeIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andNextBusinessNodeIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " >", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andNextBusinessNodeIdGreaterThanOrEqualTo(long value) {
        	return andNextBusinessNodeIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andNextBusinessNodeIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " >=", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andNextBusinessNodeIdLessThan(long value) {
        	return andNextBusinessNodeIdLessThan(Long.valueOf(value));
        }
                public Criteria andNextBusinessNodeIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " <", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andNextBusinessNodeIdLessThanOrEqualTo(long value) {
        	return andNextBusinessNodeIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andNextBusinessNodeIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " <=", value, "nextBusinessNodeId");
            return this;
        }
        
        public Criteria andNextBusinessNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.NextBusinessNodeId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andNextBusinessNodeIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andNextBusinessNodeIdIn(long[] values) {
        	if(values.length == 1){
        		return andNextBusinessNodeIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " in", values, "nextBusinessNodeId");
            	return this;
            }
        }
        
        public Criteria andNextBusinessNodeIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andNextBusinessNodeIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not in", values, "nextBusinessNodeId");
            	return this;
            }
        }
        
                public Criteria andNextBusinessNodeIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andNextBusinessNodeIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " in", values, "nextBusinessNodeId");
            	return this;
            }
        }
        public Criteria andNextBusinessNodeIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andNextBusinessNodeIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not in", values, "nextBusinessNodeId");
            	return this;
            }
        }
        
        public Criteria andNextBusinessNodeIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andNextBusinessNodeIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " in", Arrays.asList(values), "nextBusinessNodeId");
            	return this;
            }
        }
        public Criteria andNextBusinessNodeIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andNextBusinessNodeIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not in", Arrays.asList(values), "nextBusinessNodeId");
            	return this;
            }
        }
		
		public Criteria andNextBusinessNodeIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andNextBusinessNodeIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andNextBusinessNodeIdBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " between", value1, value2, "nextBusinessNodeId");
            return this;
        }
                public Criteria andNextBusinessNodeIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " between", value1, value2, "nextBusinessNodeId");
            return this;
        }
        
                
        public Criteria andNextBusinessNodeIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not between", value1, value2, "nextBusinessNodeId");
            return this;
        }
                public Criteria andNextBusinessNodeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.NextBusinessNodeId + " not between", value1, value2, "nextBusinessNodeId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessNodeNameIsNull() {
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " is null");
            return this;
        }
        public Criteria andBusinessNodeNameIsNotNull() {
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " is not null");
            return this;
        }
    
        public Criteria andBusinessNodeNameIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " is not null AND " + IBusinessNodeDAO.BusinessNodeName + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessNodeNameIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.BusinessNodeName + " is null OR " + IBusinessNodeDAO.BusinessNodeName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andBusinessNodeNameEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " = ", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andBusinessNodeNameNotEqualTo(String value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " <>", value, "businessNodeName");
            return this;
        }
               
        public Criteria andBusinessNodeNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " is null OR " + IBusinessNodeDAO.BusinessNodeName + " <>", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessNodeNameGreaterThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " >", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessNodeNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " >=", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeNameLessThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " <", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeNameLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " <=", value, "businessNodeName");
            return this;
        }
        
        public Criteria andBusinessNodeNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andBusinessNodeNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " like", buffer.toString(), "businessNodeName");
            return this;
        }
        public Criteria andBusinessNodeNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " not like", buffer.toString(), "businessNodeName");
            return this;
        }
                
                public Criteria andBusinessNodeNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andBusinessNodeNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeName + " in", values, "businessNodeName");
            	return this;
            }
        }
        public Criteria andBusinessNodeNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andBusinessNodeNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeName + " not in", values, "businessNodeName");
            	return this;
            }
        }
        
        public Criteria andBusinessNodeNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andBusinessNodeNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeName + " in", Arrays.asList(values), "businessNodeName");
            	return this;
            }
        }
        public Criteria andBusinessNodeNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andBusinessNodeNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeName + " not in", Arrays.asList(values), "businessNodeName");
            	return this;
            }
        }
		
		public Criteria andBusinessNodeNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessNodeNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeNameBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " between", value1, value2, "businessNodeName");
            return this;
        }
        
                public Criteria andBusinessNodeNameNotBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.BusinessNodeName + " not between", value1, value2, "businessNodeName");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessNodeTypeIsNull() {
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " is null");
            return this;
        }
        public Criteria andBusinessNodeTypeIsNotNull() {
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " is not null");
            return this;
        }
    
        public Criteria andBusinessNodeTypeIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " is not null AND " + IBusinessNodeDAO.BusinessNodeType + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessNodeTypeIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.BusinessNodeType + " is null OR " + IBusinessNodeDAO.BusinessNodeType + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andBusinessNodeTypeEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " = ", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andBusinessNodeTypeNotEqualTo(String value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " <>", value, "businessNodeType");
            return this;
        }
               
        public Criteria andBusinessNodeTypeNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " is null OR " + IBusinessNodeDAO.BusinessNodeType + " <>", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessNodeTypeGreaterThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " >", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessNodeTypeGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " >=", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeTypeLessThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " <", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeTypeLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " <=", value, "businessNodeType");
            return this;
        }
        
        public Criteria andBusinessNodeTypeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.BusinessNodeType);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeTypeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andBusinessNodeTypeLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " like", buffer.toString(), "businessNodeType");
            return this;
        }
        public Criteria andBusinessNodeTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " not like", buffer.toString(), "businessNodeType");
            return this;
        }
                
                public Criteria andBusinessNodeTypeIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andBusinessNodeTypeEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeType + " in", values, "businessNodeType");
            	return this;
            }
        }
        public Criteria andBusinessNodeTypeNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andBusinessNodeTypeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeType + " not in", values, "businessNodeType");
            	return this;
            }
        }
        
        public Criteria andBusinessNodeTypeIn(String[] values) {
        	
        	if(values.length == 1){
        		return andBusinessNodeTypeEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeType + " in", Arrays.asList(values), "businessNodeType");
            	return this;
            }
        }
        public Criteria andBusinessNodeTypeNotIn(String[] values) {
        	if(values.length == 1){
        		return andBusinessNodeTypeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.BusinessNodeType + " not in", Arrays.asList(values), "businessNodeType");
            	return this;
            }
        }
		
		public Criteria andBusinessNodeTypeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessNodeTypeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.BusinessNodeType + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessNodeTypeBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " between", value1, value2, "businessNodeType");
            return this;
        }
        
                public Criteria andBusinessNodeTypeNotBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.BusinessNodeType + " not between", value1, value2, "businessNodeType");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andDeleteFlagIsNull() {
            addCriterion(IBusinessNodeDAO.DeleteFlag + " is null");
            return this;
        }
        public Criteria andDeleteFlagIsNotNull() {
            addCriterion(IBusinessNodeDAO.DeleteFlag + " is not null");
            return this;
        }
    
        public Criteria andDeleteFlagIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.DeleteFlag + " is not null AND " + IBusinessNodeDAO.DeleteFlag + " <> ''");
            return this;
        }
    		
    	public Criteria andDeleteFlagIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.DeleteFlag + " is null OR " + IBusinessNodeDAO.DeleteFlag + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andDeleteFlagEqualTo(long value) {
        	return andDeleteFlagEqualTo(Long.valueOf(value));
        }
               public Criteria andDeleteFlagEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.DeleteFlag + " = ", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andDeleteFlagNotEqualTo(long value) {
        	return andDeleteFlagNotEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
               
        public Criteria andDeleteFlagNotEqualToOrIsNull(long value) {
        	return andDeleteFlagNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andDeleteFlagNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessNodeDAO.DeleteFlag + " is null OR " + IBusinessNodeDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThan(long value) {
        	return andDeleteFlagGreaterThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.DeleteFlag + " >", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThanOrEqualTo(long value) {
        	return andDeleteFlagGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.DeleteFlag + " >=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThan(long value) {
        	return andDeleteFlagLessThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.DeleteFlag + " <", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThanOrEqualTo(long value) {
        	return andDeleteFlagLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessNodeDAO.DeleteFlag + " <=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.DeleteFlag);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andDeleteFlagIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagNotIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
                public Criteria andDeleteFlagIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andDeleteFlagEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andDeleteFlagNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andDeleteFlagEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.DeleteFlag + " not in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
		
		public Criteria andDeleteFlagIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andDeleteFlagNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.DeleteFlag + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
        
                
        public Criteria andDeleteFlagNotBetween(long value1,long value2) {
        	addCriterion(IBusinessNodeDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessNodeDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStatusIsNull() {
            addCriterion(IBusinessNodeDAO.Status + " is null");
            return this;
        }
        public Criteria andStatusIsNotNull() {
            addCriterion(IBusinessNodeDAO.Status + " is not null");
            return this;
        }
    
        public Criteria andStatusIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.Status + " is not null AND " + IBusinessNodeDAO.Status + " <> ''");
            return this;
        }
    		
    	public Criteria andStatusIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.Status + " is null OR " + IBusinessNodeDAO.Status + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStatusEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Status + " = ", value, "status");
            return this;
        }
        
        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStatusNotEqualTo(String value) {
        	        
            addCriterion(IBusinessNodeDAO.Status + " <>", value, "status");
            return this;
        }
               
        public Criteria andStatusNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessNodeDAO.Status + " is null OR " + IBusinessNodeDAO.Status + " <>", value, "status");
            return this;
        }
        
        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.Status + " >", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Status + " >=", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.Status + " <", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Status + " <=", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Status);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStatusLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.Status + " like", buffer.toString(), "status");
            return this;
        }
        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.Status + " not like", buffer.toString(), "status");
            return this;
        }
                
                public Criteria andStatusIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStatusEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Status + " in", values, "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStatusNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Status + " not in", values, "status");
            	return this;
            }
        }
        
        public Criteria andStatusIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStatusEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Status + " in", Arrays.asList(values), "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(String[] values) {
        	if(values.length == 1){
        		return andStatusNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Status + " not in", Arrays.asList(values), "status");
            	return this;
            }
        }
		
		public Criteria andStatusIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Status + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.Status + " between", value1, value2, "status");
            return this;
        }
        
                public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.Status + " not between", value1, value2, "status");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRemarksIsNull() {
            addCriterion(IBusinessNodeDAO.Remarks + " is null");
            return this;
        }
        public Criteria andRemarksIsNotNull() {
            addCriterion(IBusinessNodeDAO.Remarks + " is not null");
            return this;
        }
    
        public Criteria andRemarksIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.Remarks + " is not null AND " + IBusinessNodeDAO.Remarks + " <> ''");
            return this;
        }
    		
    	public Criteria andRemarksIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.Remarks + " is null OR " + IBusinessNodeDAO.Remarks + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRemarksEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Remarks + " = ", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRemarksNotEqualTo(String value) {
        	        
            addCriterion(IBusinessNodeDAO.Remarks + " <>", value, "remarks");
            return this;
        }
               
        public Criteria andRemarksNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessNodeDAO.Remarks + " is null OR " + IBusinessNodeDAO.Remarks + " <>", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.Remarks + " >", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Remarks + " >=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.Remarks + " <", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.Remarks + " <=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.Remarks);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRemarksLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.Remarks + " like", buffer.toString(), "remarks");
            return this;
        }
        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.Remarks + " not like", buffer.toString(), "remarks");
            return this;
        }
                
                public Criteria andRemarksIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRemarksEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Remarks + " in", values, "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRemarksNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Remarks + " not in", values, "remarks");
            	return this;
            }
        }
        
        public Criteria andRemarksIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRemarksEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Remarks + " in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(String[] values) {
        	if(values.length == 1){
        		return andRemarksNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.Remarks + " not in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
		
		public Criteria andRemarksIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.Remarks + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.Remarks + " between", value1, value2, "remarks");
            return this;
        }
        
                public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.Remarks + " not between", value1, value2, "remarks");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andProcessDiagramNodeIdIsNull() {
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " is null");
            return this;
        }
        public Criteria andProcessDiagramNodeIdIsNotNull() {
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " is not null");
            return this;
        }
    
        public Criteria andProcessDiagramNodeIdIsNotEmpty() {        
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " is not null AND " + IBusinessNodeDAO.ProcessDiagramNodeId + " <> ''");
            return this;
        }
    		
    	public Criteria andProcessDiagramNodeIdIsEmpty() {       
            addCriterion("(" + IBusinessNodeDAO.ProcessDiagramNodeId + " is null OR " + IBusinessNodeDAO.ProcessDiagramNodeId + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andProcessDiagramNodeIdEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " = ", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andProcessDiagramNodeIdNotEqualTo(String value) {
        	        
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " <>", value, "processDiagramNodeId");
            return this;
        }
               
        public Criteria andProcessDiagramNodeIdNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " is null OR " + IBusinessNodeDAO.ProcessDiagramNodeId + " <>", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andProcessDiagramNodeIdGreaterThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " >", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andProcessDiagramNodeIdGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " >=", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andProcessDiagramNodeIdLessThan(String value) {
        				
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " <", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andProcessDiagramNodeIdLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " <=", value, "processDiagramNodeId");
            return this;
        }
        
        public Criteria andProcessDiagramNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessNodeDAO.ProcessDiagramNodeId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andProcessDiagramNodeIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andProcessDiagramNodeIdLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " like", buffer.toString(), "processDiagramNodeId");
            return this;
        }
        public Criteria andProcessDiagramNodeIdNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " not like", buffer.toString(), "processDiagramNodeId");
            return this;
        }
                
                public Criteria andProcessDiagramNodeIdIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andProcessDiagramNodeIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " in", values, "processDiagramNodeId");
            	return this;
            }
        }
        public Criteria andProcessDiagramNodeIdNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andProcessDiagramNodeIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " not in", values, "processDiagramNodeId");
            	return this;
            }
        }
        
        public Criteria andProcessDiagramNodeIdIn(String[] values) {
        	
        	if(values.length == 1){
        		return andProcessDiagramNodeIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " in", Arrays.asList(values), "processDiagramNodeId");
            	return this;
            }
        }
        public Criteria andProcessDiagramNodeIdNotIn(String[] values) {
        	if(values.length == 1){
        		return andProcessDiagramNodeIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " not in", Arrays.asList(values), "processDiagramNodeId");
            	return this;
            }
        }
		
		public Criteria andProcessDiagramNodeIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andProcessDiagramNodeIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andProcessDiagramNodeIdBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " between", value1, value2, "processDiagramNodeId");
            return this;
        }
        
                public Criteria andProcessDiagramNodeIdNotBetween(String value1, String value2) {
            addCriterion(IBusinessNodeDAO.ProcessDiagramNodeId + " not between", value1, value2, "processDiagramNodeId");
            return this;
        }
        
            	
    	    	
    	        
        
    }
	
    
}